Axis functions

CubePlayer allows you to use functions directly on the result table:

 

·          On the entire axis

·          On the each dimension on the axis

 

If you apply on the one dimension on the axis, and there is more dimensions then one, enumeration will take place.

That means that complex MDX syntax will be replaced with the list of members from that dimension.

 

Functions you can apply are:

 

·          TopCount

·          TopPercent

·          TopSum

·          BottomCount

·          BottomPercent

·          BottomSum

·          Head

·          Tail

·          Filter

·          Order

 

More:

Apply function to the axis